package com.ys.mapper.amazonorder;

import java.util.List;
import java.util.Map;

import com.ys.entity.amazonorder.TcoRankShopByAmountRmb;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.ys.entity.amazonorder.TpAmazonShopOrder;

@Mapper
public interface AmazonorderMapper {

	public void deleteBatchTpAmazonShopOrderOriginBySeller(@Param("sellerId")String sellerId);

	public void deleteBatchTpAmazonShopOrderLatestBySeller(@Param("sellerId")String sellerId);

	public int insertBatchTpAmazonShopOrderLatestBySeller(@Param("sellerId")String sellerId);

	public void deleteBatchTpAmazonShopOrderBySeller(@Param("sellerId")String sellerId);

	public int insertBatchTpAmazonShopOrderBySeller(@Param("sellerId")String sellerId);
    
    /**
     * 删除报告记录
     * @param createTimeMax 最大创建时间
     * @return
     */
    public int deleteBatchTpAmazonSellerReport(@Param("createTimeMax")String createTimeMax);

	public int insertBatchTpAmazonShopOrderLatestByList(List<TpAmazonShopOrder> list);

	public int updateTpAmazonShopOrderBatch();

	public void deleteBatchTpAmazonShopOrderDailyByDay(@Param("day")String day);

	public void deleteBatchTpAmazonShopOrderDailyByDayAndSeller(@Param("day")String day, @Param("sellerId")String sellerId);

	public int insertBatchTpAmazonShopOrderDailyByDay(@Param("day")String day);

	public int insertBatchTpAmazonShopOrderDailyByDayAndSeller(@Param("day")String day, @Param("sellerId")String sellerId);

	public int updateCountTpAmazonShopOrderDailyByDay(@Param("day")String day);

	public int updateCountTpAmazonShopOrderDailyByDayAndSeller(@Param("day")String day, @Param("sellerId")String sellerId);

	public void deleteBatchTcoYearAll(@Param("year")String year);

	public void deleteBatchTcoYearCountry(@Param("year")String year);

	public void deleteBatchTcoYearRegion(@Param("year")String year);

	public void deleteBatchTcoYearShop(@Param("year")String year);

	public void deleteBatchTcoYearProduct(@Param("year")String year);

	public void deleteBatchTcoYearProductYP(@Param("year")String year);

	public void deleteBatchTcoYearProductJP(@Param("year")String year);

	public void deleteBatchTcoYearProductJPNORTH(@Param("year")String year);

	public void deleteBatchTcoYearProductJPEUROPE(@Param("year")String year);

	public void deleteBatchTcoYearProductYPSum(@Param("year")String year);

	public void deleteBatchTcoYearProductJPSum(@Param("year")String year);

	public void deleteBatchTcoYearProductType(@Param("year")String year);

	public void deleteBatchTcoMonthAll(@Param("month")String month);

	public void deleteBatchTcoMonthCountry(@Param("month")String month);

	public void deleteBatchTcoMonthRegion(@Param("month")String month);

	public void deleteBatchTcoMonthShop(@Param("month")String month);

	public void deleteBatchTcoMonthProduct(@Param("month")String month);

	public void deleteBatchTcoMonthProductYP(@Param("month")String month);

	public void deleteBatchTcoMonthProductJP(@Param("month")String month);

	public void deleteBatchTcoMonthProductJPNORTH(@Param("month")String month);

	public void deleteBatchTcoMonthProductJPEUROPE(@Param("month")String month);

	public void deleteBatchTcoMonthProductYPSum(@Param("month")String month);

	public void deleteBatchTcoMonthProductJPSum(@Param("month")String month);

	public void deleteBatchTcoMonthProductType(@Param("month")String month);

	public void deleteBatchTcoDayAll(@Param("day")String day);

	public void deleteBatchTcoDayCountry(@Param("day")String day);

	public void deleteBatchTcoDayRegion(@Param("day")String day);

	public void deleteBatchTcoDayShop(@Param("day")String day);

	public void deleteBatchTcoDayProduct(@Param("day")String day);

	public void deleteBatchTcoDayProductYP(@Param("day")String day);

	public void deleteBatchTcoDayProductJP(@Param("day")String day);

	public void deleteBatchTcoDayProductJPNORTH(@Param("day")String day);

	public void deleteBatchTcoDayProductJPEUROPE(@Param("day")String day);

	public void deleteBatchTcoDayProductJPSum(@Param("day")String day);

	public void deleteBatchTcoDayProductType(@Param("day")String day);

	public int insertBatchTcoYearAll(@Param("year")String year);

	public int insertBatchTcoYearCountry(@Param("year")String year);

	public int insertBatchTcoYearRegion(@Param("year")String year);

	public int insertBatchTcoYearShop(@Param("year")String year);

	public int insertBatchTcoYearProduct(@Param("year")String year);

	public int insertBatchTcoYearProductYP(@Param("year")String year);

	public int insertBatchTcoYearProductJP(@Param("year")String year);

	public int insertBatchTcoYearProductJPNORTH(@Param("year")String year);

	public int insertBatchTcoYearProductJPEUROPE(@Param("year")String year);

	public int insertBatchTcoYearProductYPSum(@Param("year")String year);

	public int insertBatchTcoYearProductJPSum(@Param("year")String year);

	public int insertBatchTcoYearProductType(@Param("year")String year);

	public int insertBatchTcoMonthAll(@Param("month")String month);

	public int insertBatchTcoMonthCountry(@Param("month")String month);

	public int insertBatchTcoMonthRegion(@Param("month")String month);

	public int insertBatchTcoMonthShop(@Param("month")String month);

	public int insertBatchTcoMonthProduct(@Param("month")String month);

	public int insertBatchTcoMonthProductYP(@Param("month")String month);

	public int insertBatchTcoMonthProductJP(@Param("month")String month);

	public int insertBatchTcoMonthProductJPNORTH(@Param("month")String month);

	public int insertBatchTcoMonthProductJPEUROPE(@Param("month")String month);

	public int insertBatchTcoMonthProductYPSum(@Param("month")String month);

	public int insertBatchTcoMonthProductJPSum(@Param("month")String month);

	public int insertBatchTcoMonthProductType(@Param("month")String month);

	public int insertBatchTcoDayAll(@Param("day")String day);

	public int insertBatchTcoDayCountry(@Param("day")String day);

	public int insertBatchTcoDayRegion(@Param("day")String day);

	public int insertBatchTcoDayShop(@Param("day")String day);

	public void updateBatchTcoDayShop(@Param("day")String day);

	public int insertBatchTcoDayProductJP(@Param("day")String day);

	public int insertBatchTcoDayProductJPNORTH(@Param("day")String day);

	public int insertBatchTcoDayProductJPEUROPE(@Param("day")String day);

	public int insertBatchTcoDayProductJPSum(@Param("day")String day);

	public void updateBatchTcoYearProductType(@Param("year")String year);

	public void updateBatchTcoMonthProductType(@Param("month")String month);

	public void updateBatchTcoDayProductType(@Param("day")String year);

	public void updateBatchTcoYearRegion(@Param("year")String year);

	public void updateBatchTcoMonthRegion(@Param("month")String month);

	public void updateBatchTcoDayRegion(@Param("day")String year);


	/**
	 * 店铺根据订单金额倒序的排名信息
	 */
	public List<Map<String, Object>> countRankShopByAmountRmb(@Param("dayBegin")String dayBegin,@Param("dayEnd")String dayEnd);

	/**
	 * 查询所有的店铺id信息
	 */
	public List<Long> selectShopId();

	/**
	 * 批量新增店铺根据订单金额倒序的排名信息
	 */
	public void insertTcoRankShopByAmountRmb(List<TcoRankShopByAmountRmb> list);
	/**
	 * 排名信息根据统计日期删除
	 */
	public void deleteTcoRankShopByAmountRmbByCountDate(@Param("countDate")String countDate);

}